select * from pharmacyInfo where status='1';